drop table jms_dm.dm_mng_thd_flase_send_network_summary_dt;
create table jms_dm.dm_mng_thd_flase_send_network_summary_dt
(
    first_duty_network_code varchar(100) comment '首责任机构code',
    first_duty_agent_code   varchar(100) comment '首责任机构代理区code',
    first_duty_network_type int comment '首责任机构网点类型6网点,5集散,4中心',
    date_time               date comment '录入日期',
    first_duty_network_name varchar(100) comment '首责任机构name',
    first_duty_agent_name   varchar(100) comment '首责任机构代理区name',
    all_num                 int comment '总件量',
    first_line_num          int comment '首条轨迹后续更新超时',
    outprov_center_num      int comment '离开所在省份最后中心超时',
    same_center_num         int comment '同一中心停留超时',
    adjacent_track          int comment '相邻物流轨迹更新超时',
    update_time             varchar(100) comment '更新时间'
) ENGINE=OLAP
DUPLICATE KEY(
 first_duty_network_code,first_duty_agent_code,first_duty_network_type
)
COMMENT "春节不打烊-桃花岛虚假发货汇总"
PARTITION BY RANGE(date_time)(
START ('2023-12-01') END ('2024-02-10') EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(first_duty_network_code) BUCKETS 1
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-360",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "3",
"in_memory" = "false",
"storage_format" = "V2"
);
